package ch.bfh.abhmcm.SoftwareEngineeringAndDesign.controller;

import java.sql.ResultSet;

import ch.bfh.abhmcm.SoftwareEngineeringAndDesign.model.RFC;

public class RFCMaker {
	

	public RFC makeanRFC(ResultSet rs)throws Exception{
		
		
		RFC rfc = new RFC(rs.getString(RFC.TC_ID));
		rfc.setSubmission_Date(rs.getString(RFC.TC_SUBMISSIONDATE));
		rfc.setChange_Owner(rs.getString(RFC.TC_CHANGEOWNER));
		rfc.setRfc_Initiator(rs.getString(RFC.TC_RFCINITIATOR));
		rfc.setStatus(rs.getString(RFC.TC_Status));
		rfc.setPriority(rs.getString(RFC.TC_PRIORITY));
		rfc.setSummary(rs.getString(RFC.TC_SUMMARY));
		rfc.setDetailed_Description(rs
				.getString(RFC.TC_DETAILEDDESCRIPTION));
		rfc.setReason_for_Change(rs.getString(RFC.TC_REASONFORCHANGE));
		rfc.setCosts(rs.getString(RFC.TC_COSTS));
		rfc.setRisks(rs.getString(RFC.TC_RISKS));
		rfc.setBenefits(rs.getString(RFC.TC_BENEFITS));
		rfc.setChange_Owner(rs.getString(RFC.TC_CHANGEOWNER));
		rfc.setChange_Approver(rs.getString(RFC.TC_CHANCHAPPROVER));
		rfc.setAffected_Services(rs.getString(RFC.TC_AFFECTEDSERVICES));
		rfc.setAffected_Infrastructure_Components(rs
				.getString(RFC.TC_AFFECTEDINFRASTRUCTURE));
		rfc.setDate_Approval_Recjection(rs
				.getString(RFC.TC_DATEOFREJECTIONORAPPROVAL));
		rfc.setApproval_charge_Person(rs
				.getString(RFC.TC_APPROVALPERSON));
		rfc.setReason_of_Rejecting(rs
				.getString(RFC.TC_REASONOFREJECTING));
		return rfc;
				
		
	}
	


	
}
